Release 10.1A: OpenEdge Data Management:
SQL Reference

CREATE USER

Creates the specified user.

Syntax

CREATE USER 'username', 'password' ;

Example

In this example an account with DBA privileges creates the ‘username’ ‘Jasper’ with password ‘spaniel’:

CREATE USER 'Jasper', 'spaniel' ;

Notes

Used in conjunction with BEGIN-END DECLARE SECTION and DROP USER statement, the CREATE USER statement provides a way to manage user records through SQL.
The user name and password must be enclosed in quotes.
Before issuing the CREATE USER statement, there are no users defined in the user table and any user can log into the database.
After issuing the CREATE USER statement, only users defined in the user table can log into the database.

Authorization

Must have DBA privileges.

Related statements

BEGIN-END DECLARE SECTION, DROP USER